import pandas as pd
import numpy as np

dates = pd.date_range('20130101', periods=6)
df = pd.DataFrame(np.arange(24).reshape((6, 4)), index=dates, columns=['A', 'B', 'C', 'D'])
print(df)
"""
             A   B   C   D
2013-01-01   0   1   2   3
2013-01-02   4   5   6   7
2013-01-03   8   9  10  11
2013-01-04  12  13  14  15
2013-01-05  16  17  18  19
2013-01-06  20  21  22  23
"""

print()
print(df['A'])

print()
print(df.A)

print(df[0:3])

print(df['20130102':'20130104'])
print()
# 用标签来选择数据 loc, 本例子主要通过标签名字选择某一行数据，
# 或者通过选择某行或者所有行（:代表所有行）然后选其中某一列或几列数据。
print(df.loc['20130102'])

print()
# 选择 A B 两列
print(df.loc[:, ['A', 'B']])

print()
print(df.loc['20130102', ['A', 'B']])

print(df.iloc[3, 1])
# 13
print(df.iloc[3])
print()
print(df.iloc[3:5, 1:3])
"""
             B   C
2013-01-04  13  14
2013-01-05  17  18
"""

print(df.iloc[[1, 3, 5], 1:3])
"""
             B   C
2013-01-02   5   6
2013-01-04  13  14
2013-01-06  21  22

"""

print(df.ix[:3,['A','C']])
"""
            A   C
2013-01-01  0   2
2013-01-02  4   6
2013-01-03  8  10
"""
print(df[df.A>8])
"""
             A   B   C   D
2013-01-04  12  13  14  15
2013-01-05  16  17  18  19
2013-01-06  20  21  22  23
"""